Jon.Gleeson wrote:
Is there a function which will convert my weight in KG to St,lb? Considering that there are 14 lb in a stone this could be tricky. I have tried dividing kg by 6.350 but of course the result is to a decimal point.
Yvan's suggestions regarding searching the forum is well taken. Unfortunately, the results shown deal with conversion in the other direction—from weight in stones to the equivalent in pounds. Helpful, but not quite what you're looking for.
Converting a mass measurement in kg to the equivalent weight measurement in stones and pounds is a two step process:
First do the kg to pounds conversion. Here are the steps in (sort of) English:
lb = kg x 2.20462262
Then separate that result into stones and pounds:
st = (quotient) lb / 14
lb = (remainder) lb / 14
Assuming you want only to display the result, and not use it in further calculations, the steps can be done in a single formula. As written, it assumes the mass in kg is contained in cell B2:
=QUOTIENT(B2*2.20462262,14)&" st. "&ROUND(MOD(B2*2.20462262,14),0)&" lb."
As written, the formula will display the weight to the nearer whole pound.
For discussion (and further examples) of the functions used, see the iWork Formulas and Functions User Guide, downloadable via the Application menu (in Numbers, the "Numbers" menu).
Regards,
Barry